﻿INSERT INTO [tblPatient] ([FirstName],[LastName],[Address],[Sex],[Tel],[DateOfBirth],[MarialStatus],[DateRegistered],[NOKFullName],[NOKRelationship],[NOKAddress],[NOKTel],[LDoctorName],[LDoctorClinic],[LDoctorAddress],[LDoctorTel],[ExNumber],[ExStaffId],[ExDate],[ExRoom]) VALUES (N'Nguyen',N'Kien',N'Danang',N'1',N'3242         ',N'19910101',N'abc       ',N'20010202',N'No Name',N'Friend',N'USA',N'123          ',N'Anh Nguyen',N'...       ',N'...',N'...          ',123,2,N'19950101',N'123       ');
GO
INSERT INTO [tblPatient] ([FirstName],[LastName],[Address],[Sex],[Tel],[DateOfBirth],[MarialStatus],[DateRegistered],[NOKFullName],[NOKRelationship],[NOKAddress],[NOKTel],[LDoctorName],[LDoctorClinic],[LDoctorAddress],[LDoctorTel],[ExNumber],[ExStaffId],[ExDate],[ExRoom]) VALUES (N'Kato',N'Solis',N'2785 Adipiscing Avenue',N'0',N'466-0423     ',N'20021002',N'vel nisl. ',N'20131029',N'Byron Gill',N'Enim LLP',N'388-7894 Euismod Av.',N'882-3873     ',N'Rashad Reese',NULL,N'8959 Sed Avenue',N'155-5034     ',NULL,NULL,NULL,NULL);
GO
INSERT INTO [tblPatient] ([FirstName],[LastName],[Address],[Sex],[Tel],[DateOfBirth],[MarialStatus],[DateRegistered],[NOKFullName],[NOKRelationship],[NOKAddress],[NOKTel],[LDoctorName],[LDoctorClinic],[LDoctorAddress],[LDoctorTel],[ExNumber],[ExStaffId],[ExDate],[ExRoom]) VALUES (N'Alden',N'Griffith',N'Ap #509-2469 In St.',N'0',N'555-8924     ',N'20101016',N'ad litora ',N'20150419',N'Uriah Sosa',N'Felis Ullamcorper Viverra Inc.',N'9839 Amet Avenue',N'117-0364     ',N'Iola Santiago',N'Morbi     ',N'235 Pharetra Ave',N'208-6773     ',27,5,N'20140409',N'96141     ');
GO
INSERT INTO [tblPatient] ([FirstName],[LastName],[Address],[Sex],[Tel],[DateOfBirth],[MarialStatus],[DateRegistered],[NOKFullName],[NOKRelationship],[NOKAddress],[NOKTel],[LDoctorName],[LDoctorClinic],[LDoctorAddress],[LDoctorTel],[ExNumber],[ExStaffId],[ExDate],[ExRoom]) VALUES (N'Jonas',N'Lyons',N'P.O. Box 688, 9871 Vitae St.',N'0',N'592-6846     ',N'19880307',N'Morbi quis',N'20130918',N'Raphael Delacruz',N'Et Nunc Quisque Foundation',N'6701 Mauris Road',N'214-3844     ',N'Shoshana Atkins',N'nisl      ',N'Ap #494-784 Mi, Rd.',N'635-4409     ',57,8,N'20130907',N'53227     ');
GO
INSERT INTO [tblPatient] ([FirstName],[LastName],[Address],[Sex],[Tel],[DateOfBirth],[MarialStatus],[DateRegistered],[NOKFullName],[NOKRelationship],[NOKAddress],[NOKTel],[LDoctorName],[LDoctorClinic],[LDoctorAddress],[LDoctorTel],[ExNumber],[ExStaffId],[ExDate],[ExRoom]) VALUES (N'Elvis',N'Banks',N'909 Lorem St.',N'1',N'873-6552     ',N'19780212',N'dictum eu,',N'20130720',N'Jared Mcfarland',N'Gravida LLC',N'596-1153 Neque Road',N'440-5245     ',N'Calista Ortega',N'et        ',N'P.O. Box 206, 5109 Mollis St.',N'806-7830     ',41,2,N'20130906',N'61456     ');
GO
INSERT INTO [tblPatient] ([FirstName],[LastName],[Address],[Sex],[Tel],[DateOfBirth],[MarialStatus],[DateRegistered],[NOKFullName],[NOKRelationship],[NOKAddress],[NOKTel],[LDoctorName],[LDoctorClinic],[LDoctorAddress],[LDoctorTel],[ExNumber],[ExStaffId],[ExDate],[ExRoom]) VALUES (N'Sawyer',N'Ellis',N'Ap #651-7862 Nullam St.',N'1',N'623-4554     ',N'19930405',N'magna. Ut ',N'20140223',N'Harper Oneill',N'Odio Vel Associates',N'Ap #265-133 Fermentum Ave',N'929-6380     ',N'Brian Miller',N'Fusce     ',N'210-312 Malesuada. Street',N'932-0278     ',2,3,N'20150223',N'09087     ');
GO
INSERT INTO [tblPatient] ([FirstName],[LastName],[Address],[Sex],[Tel],[DateOfBirth],[MarialStatus],[DateRegistered],[NOKFullName],[NOKRelationship],[NOKAddress],[NOKTel],[LDoctorName],[LDoctorClinic],[LDoctorAddress],[LDoctorTel],[ExNumber],[ExStaffId],[ExDate],[ExRoom]) VALUES (N'Callum',N'Boyle',N'2649 Donec Street',N'0',N'992-6559     ',N'19751016',N'ante ipsum',N'20150204',N'Dalton Lott',N'Eu Consulting',N'Ap #800-6696 Placerat Ave',N'352-5736     ',N'Quinlan Jensen',N'lacus.    ',N'667-2120 Risus Ave',N'324-6394     ',92,7,N'20131228',N'67363     ');
GO
INSERT INTO [tblPatient] ([FirstName],[LastName],[Address],[Sex],[Tel],[DateOfBirth],[MarialStatus],[DateRegistered],[NOKFullName],[NOKRelationship],[NOKAddress],[NOKTel],[LDoctorName],[LDoctorClinic],[LDoctorAddress],[LDoctorTel],[ExNumber],[ExStaffId],[ExDate],[ExRoom]) VALUES (N'Odysseus',N'Simmons',N'P.O. Box 554, 8118 Sit Av.',N'0',N'655-2421     ',N'19830603',N'ligula eu ',N'20140919',N'Hall Flores',N'Pretium Aliquet Corp.',N'Ap #827-5815 Aliquet St.',N'947-2200     ',N'Grady Nicholson',N'sit       ',N'196-7741 Rutrum Av.',N'966-6939     ',72,9,N'20150410',N'63649     ');
GO
INSERT INTO [tblPatient] ([FirstName],[LastName],[Address],[Sex],[Tel],[DateOfBirth],[MarialStatus],[DateRegistered],[NOKFullName],[NOKRelationship],[NOKAddress],[NOKTel],[LDoctorName],[LDoctorClinic],[LDoctorAddress],[LDoctorTel],[ExNumber],[ExStaffId],[ExDate],[ExRoom]) VALUES (N'Cade',N'Richard',N'P.O. Box 320, 7421 Ultricies Street',N'1',N'905-7158     ',N'19940531',N'Sed diam  ',N'20150519',N'Coby Garrison',N'Diam Vel Corp.',N'129-5408 Quis Ave',N'446-9353     ',N'Bruce Yang',N'Aliquam   ',N'582-3519 Eros Ave',N'544-6198     ',33,6,N'20140922',N'99942     ');
GO
INSERT INTO [tblPatient] ([FirstName],[LastName],[Address],[Sex],[Tel],[DateOfBirth],[MarialStatus],[DateRegistered],[NOKFullName],[NOKRelationship],[NOKAddress],[NOKTel],[LDoctorName],[LDoctorClinic],[LDoctorAddress],[LDoctorTel],[ExNumber],[ExStaffId],[ExDate],[ExRoom]) VALUES (N'Tad',N'Mendez',N'750 Sem Av.',N'1',N'700-6849     ',N'19970511',N'semper et,',N'20140305',N'Shad Klein',N'Nullam LLP',N'Ap #533-2952 Et St.',N'785-9135     ',N'Russell Torres',N'Nullam    ',N'759-617 Dictum. Road',N'444-8731     ',59,7,N'20140627',N'22194     ');
GO
INSERT INTO [tblPatient] ([FirstName],[LastName],[Address],[Sex],[Tel],[DateOfBirth],[MarialStatus],[DateRegistered],[NOKFullName],[NOKRelationship],[NOKAddress],[NOKTel],[LDoctorName],[LDoctorClinic],[LDoctorAddress],[LDoctorTel],[ExNumber],[ExStaffId],[ExDate],[ExRoom]) VALUES (N'Camden',N'Burns',N'3362 Egestas. St.',N'1',N'344-6902     ',N'19940423',N'congue a, ',N'20140903',N'Hakeem Buckley',N'Sed Associates',N'Ap #405-7182 Diam Street',N'687-8688     ',N'Cain Bell',N'tortor    ',N'P.O. Box 455, 5627 Aliquet, Rd.',N'720-2968     ',17,1,N'20131012',N'23848     ');
GO
INSERT INTO [tblPatient] ([FirstName],[LastName],[Address],[Sex],[Tel],[DateOfBirth],[MarialStatus],[DateRegistered],[NOKFullName],[NOKRelationship],[NOKAddress],[NOKTel],[LDoctorName],[LDoctorClinic],[LDoctorAddress],[LDoctorTel],[ExNumber],[ExStaffId],[ExDate],[ExRoom]) VALUES (N'Amos',N'Stewart',N'889-437 Tristique Road',N'0',N'582-0377     ',N'19930312',N'velit dui,',N'20140102',N'Merritt Odom',N'Penatibus Et Industries',N'Ap #305-8301 Egestas. Rd.',N'654-1501     ',N'Venus Blackburn',N'torquent  ',N'127 Ac Av.',N'929-3362     ',58,1,N'20130814',N'15894     ');
GO
INSERT INTO [tblPatient] ([FirstName],[LastName],[Address],[Sex],[Tel],[DateOfBirth],[MarialStatus],[DateRegistered],[NOKFullName],[NOKRelationship],[NOKAddress],[NOKTel],[LDoctorName],[LDoctorClinic],[LDoctorAddress],[LDoctorTel],[ExNumber],[ExStaffId],[ExDate],[ExRoom]) VALUES (N'Hiram',N'Webb',N'6400 Enim Road',N'1',N'368-3948     ',N'19900306',N'dui. Cras ',N'20141219',N'Eagan Jones',N'Quam Vel Sapien Corporation',N'598-3678 A Road',N'904-8550     ',N'Zenaida Mckee',N'Nulla     ',N'Ap #186-9327 Sodales Rd.',N'995-7014     ',25,8,N'20140203',N'09990     ');
GO
INSERT INTO [tblPatient] ([FirstName],[LastName],[Address],[Sex],[Tel],[DateOfBirth],[MarialStatus],[DateRegistered],[NOKFullName],[NOKRelationship],[NOKAddress],[NOKTel],[LDoctorName],[LDoctorClinic],[LDoctorAddress],[LDoctorTel],[ExNumber],[ExStaffId],[ExDate],[ExRoom]) VALUES (N'Dolan',N'Horne',N'970-2979 Convallis St.',N'0',N'956-8303     ',N'19890922',N'Proin vel ',N'20140326',N'Wallace Grimes',N'Sem PC',N'235-7886 Adipiscing Av.',N'416-7896     ',N'Lilah Mcfarland',N'auctor.   ',N'P.O. Box 727, 7755 Tincidunt Ave',N'602-7291     ',9,2,N'20140717',N'22655     ');
GO
INSERT INTO [tblPatient] ([FirstName],[LastName],[Address],[Sex],[Tel],[DateOfBirth],[MarialStatus],[DateRegistered],[NOKFullName],[NOKRelationship],[NOKAddress],[NOKTel],[LDoctorName],[LDoctorClinic],[LDoctorAddress],[LDoctorTel],[ExNumber],[ExStaffId],[ExDate],[ExRoom]) VALUES (N'Jelani',N'Cantu',N'P.O. Box 296, 9689 Ut Rd.',N'0',N'135-4253     ',N'20090910',N'at pede.  ',N'20141110',N'Louis Rios',N'Quis Institute',N'Ap #961-4243 Nec, Street',N'295-6840     ',N'Kerry Myers',N'placerat. ',N'990-3895 Nec Street',N'306-4744     ',8,7,N'20140811',N'37066     ');
GO
INSERT INTO [tblPatient] ([FirstName],[LastName],[Address],[Sex],[Tel],[DateOfBirth],[MarialStatus],[DateRegistered],[NOKFullName],[NOKRelationship],[NOKAddress],[NOKTel],[LDoctorName],[LDoctorClinic],[LDoctorAddress],[LDoctorTel],[ExNumber],[ExStaffId],[ExDate],[ExRoom]) VALUES (N'Simon',N'Walton',N'767-6707 Pharetra Av.',N'0',N'576-7269     ',N'20110116',N'eu neque  ',N'20131225',N'Kelly Mooney',N'Amet Risus Inc.',N'Ap #959-6388 Lectus St.',N'492-3816     ',N'Kiona Stevens',N'lacus     ',N'808 Amet St.',N'136-1205     ',95,1,N'20130809',N'59766     ');
GO
INSERT INTO [tblPatient] ([FirstName],[LastName],[Address],[Sex],[Tel],[DateOfBirth],[MarialStatus],[DateRegistered],[NOKFullName],[NOKRelationship],[NOKAddress],[NOKTel],[LDoctorName],[LDoctorClinic],[LDoctorAddress],[LDoctorTel],[ExNumber],[ExStaffId],[ExDate],[ExRoom]) VALUES (N'Ignatius',N'Anthony',N'Ap #400-5305 Diam Avenue',N'0',N'713-9481     ',N'20051030',N'turpis non',N'20130904',N'Caldwell Griffin',N'Eu Nulla At Limited',N'871-584 Molestie Street',N'938-1089     ',N'Blythe Chan',N'mi        ',N'245-8118 Lobortis Road',N'722-3527     ',6,3,N'20130827',N'26350     ');
GO
INSERT INTO [tblPatient] ([FirstName],[LastName],[Address],[Sex],[Tel],[DateOfBirth],[MarialStatus],[DateRegistered],[NOKFullName],[NOKRelationship],[NOKAddress],[NOKTel],[LDoctorName],[LDoctorClinic],[LDoctorAddress],[LDoctorTel],[ExNumber],[ExStaffId],[ExDate],[ExRoom]) VALUES (N'Hayes',N'Reed',N'Ap #807-3339 Sed Street',N'1',N'161-1564     ',N'19770721',N'lorem eu  ',N'20140911',N'Tyler Gibson',N'Dictum Ltd',N'942-9125 Sed, Av.',N'466-9473     ',N'Stone Odonnell',N'nostra,   ',N'P.O. Box 871, 1204 Tincidunt Rd.',N'813-8358     ',72,6,N'20131125',N'65911     ');
GO
INSERT INTO [tblPatient] ([FirstName],[LastName],[Address],[Sex],[Tel],[DateOfBirth],[MarialStatus],[DateRegistered],[NOKFullName],[NOKRelationship],[NOKAddress],[NOKTel],[LDoctorName],[LDoctorClinic],[LDoctorAddress],[LDoctorTel],[ExNumber],[ExStaffId],[ExDate],[ExRoom]) VALUES (N'Fulton',N'Sutton',N'Ap #327-1989 Ligula. Rd.',N'1',N'195-5091     ',N'19770626',N'magna nec ',N'20140601',N'Marvin Hamilton',N'Faucibus Morbi Corporation',N'P.O. Box 655, 1646 Faucibus Road',N'823-5358     ',N'Leigh Weaver',N'egestas   ',N'686-2629 Non Rd.',N'240-8355     ',82,3,N'20141211',N'90612     ');
GO
INSERT INTO [tblPatient] ([FirstName],[LastName],[Address],[Sex],[Tel],[DateOfBirth],[MarialStatus],[DateRegistered],[NOKFullName],[NOKRelationship],[NOKAddress],[NOKTel],[LDoctorName],[LDoctorClinic],[LDoctorAddress],[LDoctorTel],[ExNumber],[ExStaffId],[ExDate],[ExRoom]) VALUES (N'Nigel',N'Hendricks',N'Ap #299-2412 Varius Av.',N'0',N'547-8793     ',N'19800831',N'justo eu  ',N'20130702',N'Leo Hendricks',N'Vestibulum Ante Ipsum Inc.',N'8416 Ipsum Rd.',N'155-4841     ',N'Colt Osborn',N'Etiam     ',N'210 Mauris, St.',N'968-5510     ',29,4,N'20141011',N'60318     ');
GO
INSERT INTO [tblPatient] ([FirstName],[LastName],[Address],[Sex],[Tel],[DateOfBirth],[MarialStatus],[DateRegistered],[NOKFullName],[NOKRelationship],[NOKAddress],[NOKTel],[LDoctorName],[LDoctorClinic],[LDoctorAddress],[LDoctorTel],[ExNumber],[ExStaffId],[ExDate],[ExRoom]) VALUES (N'Aristotle',N'Mullen',N'P.O. Box 816, 1021 Diam. St.',N'0',N'911-8315     ',N'20020101',N'mi pede,  ',N'20140201',N'Felix Barber',N'Scelerisque Associates',N'891-2480 Dui St.',N'464-5755     ',N'Dale Raymond',N'neque     ',N'2891 Sociis St.',N'198-9785     ',14,2,N'20130815',N'83408     ');
GO
